package model;

public class MySQLInfo
{
/*
   // EC2 Database
   private String dbName = "testdatabase";
   private String dbuserName = "cromvary";
   private String dbpassword = "9Kuskup1";
   private String hostname = "testdatabase.crkptu8dcf8x.us-west-2.rds.amazonaws.com";
   private String port = "3306";
   private String table = "testtable";
*/

   // Local Database
   private String dbName = "CDH";
   private String dbuserName = "cromvary";
   private String dbpassword = "9Kuskup1";
   private String hostname = "localhost";
   private String port = "3306";
   private String acctable = "accountInfo";
   private String demtable = "demographicInfo";
   private String edutable = "educationInfo";
   private String pretable = "preferenceInfo";

   
   public String getDbName() {
      return dbName;
   }
   public void setDbName(String dbName) {
      this.dbName = dbName;
   }

   public String getDbuserName() {
      return dbuserName;
   }
   public void setDbuserName(String dbuserName) {
      this.dbuserName = dbuserName;
   }

   public String getDbpassword() {
      return dbpassword;
   }
   public void setDbpassword(String dbpassword) {
      this.dbpassword = dbpassword;
   }

   public String getHostname() {
      return hostname;
   }
   public void setHostname(String hostname) {
      this.hostname = hostname;
   }

   public String getPort() {
      return port;
   }
   public void setPort(String port) {
      this.port = port;
   }
   
   public String getAcctable() {
      return acctable;
   }
   public void setAcctable(String acctable) {
      this.acctable = acctable;
   }

   public String getDemtable() {
      return demtable;
   }
   public void setDemtable(String demtable) {
      this.demtable = demtable;
   }

   public String getEdutable() {
      return edutable;
   }
   public void setEdutable(String edutable) {
      this.edutable = edutable;
   }

   public String getPretable() {
      return pretable;
   }
   public void setPretable(String pretable) {
      this.pretable = pretable;
   }

   public String getJDBCDriver()
   {
      String JDBC_DRIVER = "com.mysql.jdbc.Driver";
      return JDBC_DRIVER;
   }

   public String getDBUrl()
   {
      String DB_URL = "jdbc:mysql://" + this.hostname + ":" + this.port + "/" + this.dbName + "?user=" + this.dbuserName + "&password=" + this.dbpassword;
      return DB_URL;  
   }

	
}
